package org.medicalinstrument.dao;



import org.medicalinstrument.bean.PurchaseOrderDetail;
import org.medicalinstrument.bean.PurchaseOrder;
import org.medicalinstrument.bean.PurchaseOrderMaster;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface PurchaseOrderDao {
    List<PurchaseOrderMaster> getAllPurchaseOrderList() throws Exception;


    List<PurchaseOrderMaster> optionSelect(String accountNo, String timein, String timeout) throws SQLException;

    int modifyOrder( String custPhone, String getOrConsigee, String state, String consigeeAddr, String orderId,String accountNo,String productQR) throws SQLException;

    int delete(String orderId, String accountNo) throws SQLException;

    List<PurchaseOrder> getOrderByCustomer( String accountNo ) throws SQLException;

    Boolean PurchasrDetail_add(Connection conn, PurchaseOrderDetail pd) throws SQLException;

    Boolean PurchaseMaster_add(Connection conn, PurchaseOrderMaster pm) throws Exception;

    Boolean updateShoppingCart(PurchaseOrderDetail pd) throws SQLException;

    List<PurchaseOrder> getOrderDetail(String orderId,String accountNo)throws SQLException;

    List<PurchaseOrder> optionsSelect(String name, String accountNo, String timein, String timeout) throws SQLException;
}
